Mastering PLSQL Through Illustrations by Dr. B. CHANDRA

Author:Dr. B. CHANDRA [Chandra, Dr. B.]
Language: eng
Format: epub
ISBN: 9789389898484
Publisher: BPB Publications
Published: 2021-09-15T00:00:00+00:00

Objective

There are two types of subprograms viz. procedures and functions. The chapter is mainly devoted to describing procedures in PL/SQL. Using Procedures, logical modules can be written and hence can be used across PL/SQL Blocks/codes. A procedure may have parameters of different types and different modes. A procedure can be invoked using different notations. Number of illustrations have been given using database tables for creating a procedure and invoking the procedure.

6.1 Subprograms

Subprograms have a declarative part, an executable part, and an optional exception-handling part just like any PL/SQL block. The declarative part contains declarations of types, cursors, constants, variables, exceptions, and nested subprograms. All these declared objects ate completely local and they do not exist after you exit the subprogram. The executable part contains assignment statements, control statements and Oracle data can also be manipulated.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.